import openpyxl
class ReadExcel:
    @staticmethod
    def read_excel(file_name,sheet_name):
        workbook=openpyxl.load_workbook(file_name)
        sheet=workbook[sheet_name]
        data=[[sheet.cell(row=i,column=j).value for j in range(1,sheet.max_column+1)] for i in range(2,sheet.max_row+1)]
        return data
if __name__=='__main__':
    data=ReadExcel.read_excel(r'G:\VScode_Folder\crocuser\必要的学习\测试\test_file\person.xlsx','Sheet1')
    for i in data:
        print(i)